ESI Operating Statistics

The ESI Operating Statistics function creates an export file of the information found in the Weekly Operating Statistic Report for the week end date selected.

1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.

2. At the Year field, enter the accounting year for the ESI operating statistics file.

3. At the Week Ending Date field, enter the week ending date for the ESI operating statistics file.

Note: The week ending date must be a Saturday. If the date entered is not a Saturday, the following message will display: " Date must be a Saturday!!! Space bar to continue."

If the file name and type selected already exist, the following message will display: "Warning: File already exists!!! Continue? No/Yes."

• Select no to return to the Year field.
• Select yes to create a new file with the same name that already exists.

4. The following message will display: "Print report? No/Yes."

• Select no to generate the export file without a printed detail report.
• Select yes to create the file with a printed detail report.

5. The following message will appear: "Create a delimited ASC file? No/Yes."

• Select no to create a DBF file only.
• Select yes to create a DBF file and an ASC file

Make the appropriate selection.

If you selected yes in Step #4 to print an ESI operating statistics report, command options will appear allowing you to print or choose from a set of other print options. If you entered no in Step #4 you will return to the Period field.

Two DBF files will be created OSMMDDYYYY.dbf andOS_Last.dbf in the Shared \NetYield\Data\Company Name\ESI Outbox folder. The OSMMDDYYYY.dbf file is the ESI Operating Statistic file for the week end date with MMDDYYYY equal to the week end date selected The OS_Last.dbf is a copy of the current file. If an ASC file was created the name will be OSMMDDYYYY.asc and will be found in the Shared \NetYield\Data\Company Name\ESI Outbox folder.

The following information will print:

• Number of Invoices – The number of invoices for each day of the week selected: Sunday through Saturday
• Number of Credits – The number of credit invoices for each day of the week selected: Sunday through Saturday
• Total Dollars Invoiced – The total dollars invoiced for each day of the week selected: Sunday through Saturday
• Average Dollars per Invoice – The average invoice amount, in dollars, for each day of the week selected: Sunday through Saturday
• Average Lines per Invoice – The average number of lines per invoice for the each day of the week selected: Sunday through Saturday
• Pounds In – The weight received, in pounds, for each day of the week selected: Sunday through Saturday
• Pounds Out – The weight shipped, in pounds, for each day of the week selected: Sunday through Saturday
• Inventory Valuation – The value of the inventory, in dollars, for each day of the week selected: Sunday through Saturday
• Accounts Receivable Invoice Date – This section displays total accounts receivable dollars which fall within the invoice aging day ranges.
• Accounts Receivable Terms Date – This section displays total accounts receivable dollars which fall within the terms aging day ranges.
• Accounts Payables Received Date – This section displays total accounts payable dollars which fall within the received aging day ranges.
• Accounts Payable Terms Date – This section displays total accounts payable dollars which fall within the terms aging day ranges.
• Sales Order Fill Rate Short –This field displays the percent of sales orders that were short shipped, based on the Short Ship Tolerance % setting in Shipping Options.
• Sales Order Fill Rate Over – This field displays the percent of sales orders that were over shipped based on the Short Ship Tolerance % setting in Shipping Options.
• Purchase Order Fill Rate Short – This field displays the percent of purchase orders that were short received.
• Purchase Order Fill Rate Over –This field displays the percent of purchase orders that were over received.

The following fields will be exported from the system:

Security Required : Ledger - Ledger Reports